Microsoft Excel Q/a Practice Questions Answers Test With Solutions & More Shortcuts

Question : 21

Gridlines

a) May be turned off for display but turned on for printing

b) May be turned on or off for printing

c) The be turned off for display and printing

d) a, b and c

e) None of these

Question : 22

In Excel to drag a selected range of data to another worksheet in the same workbook, use the

a) Tab key

b) Alt key

c) Shift key

d) Ctrl key

Question : 23

In Excel when you insert an excel file into a word document. The data are

a) Hyperlinked placed in a word table

b) Linked

c) Embedded

d) Use the word menu bar and toolbars

Question : 24

In Excel name box

a) Shows the location of the previously active cell

b) Appears to the left of the formula bar

c) Appears below the status bar

d) Appears below the menu bar

Question : 25

Charts tips can

a) Show the formatting of a data label

b) Show the name of a data series

c) Show the value of data point

d) b and c

e) None of these